package com.cowin.sys.model;

import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;
import javax.persistence.*;
@Data
@Table(name = "TM_VHC_VEHICLE")
public class TmVhcVehicle {
    @Id
    @Column(name = "TM_VHC_VEHICLE_ID")
    private Long tmVhcVehicleId;

    @Column(name = "TM_OFM_ORDER_ID")
    private Long tmOfmOrderId;

    @Column(name = "MATERIAL_NO")
    private String materialNo;

    @Column(name = "TPS")
    private String tps;

    @Column(name = "VIN")
    private String vin;

    @Column(name = "CSN_BA")
    private String csnBa;

    @Column(name = "CSN_PA")
    private String csnPa;

    @Column(name = "CSN_GA")
    private String csnGa;

    @Column(name = "CSN_QA")
    private String csnQa;

    @Column(name = "ORDER_COLOR")
    private String orderColor;

    @Column(name = "PLAN_COLOR")
    private String planColor;

    @Column(name = "LAST_COLOR")
    private String lastColor;

    @Column(name = "ENGINE_NO")
    private String engineNo;

    @Column(name = "FRAME_NO")
    private String frameNo;

    @Column(name = "CHECKOUT_NO_14")
    private String checkoutNo14;

    @Column(name = "CHECKOUT_NO_15")
    private String checkoutNo15;

    @Column(name = "CHECKOUT_DATE")
    private Date checkoutDate;

    @Column(name = "PN")
    private String pn;

    @Column(name = "HOLD_COUNT")
    private BigDecimal holdCount;

    @Column(name = "IS_TEST")
    private Short isTest;

    @Column(name = "VEHICLE_STATUS")
    private String vehicleStatus;

    @Column(name = "PREV_ULOC_ID")
    private Long prevUlocId;

    @Column(name = "FC01")
    private String fc01;

    @Column(name = "FC02")
    private String fc02;

    @Column(name = "FC03")
    private String fc03;

    @Column(name = "FC04")
    private String fc04;

    @Column(name = "FC05")
    private String fc05;

    @Column(name = "GA_TIME")
    private Date gaTime;

    @Column(name = "FINISH_TIME")
    private Date finishTime;

    @Column(name = "LAST_UPDATE_TIME")
    private Date lastUpdateTime;

    @Column(name = "LAST_UPDATE_USERNAME")
    private String lastUpdateUsername;

    @Column(name = "PID")
    private Integer pid;

    @Column(name = "PID_IS_CLOSED")
    private Short pidIsClosed;

    @Column(name = "TPSFC01")
    private String tpsfc01;

    @Column(name = "TPSFC02")
    private String tpsfc02;

    @Column(name = "TPSFC03")
    private String tpsfc03;

    @Column(name = "PLANT_ID")
    private Long plantId;

    @Column(name = "BOMVERSION")
    private String bomversion;

    @Column(name = "TM_BAS_ROUTE_ID")
    private Long tmBasRouteId;

    @Column(name = "ROUTE_START_TIME")
    private Date routeStartTime;

    @Column(name = "ROUTE_START_ULOC")
    private Long routeStartUloc;

    @Column(name = "ORDER_MAP_ULOC")
    private Long orderMapUloc;

    @Column(name = "ORDER_MAP_TIME")
    private Date orderMapTime;

    @Column(name = "TPS_PRINTTIME")
    private Date tpsPrinttime;

    @Column(name = "TPS_CREATETIME")
    private Date tpsCreatetime;

    @Column(name = "IS_WBS_SENDED")
    private Short isWbsSended;

    @Column(name = "WBS_SENDING_TIME")
    private Date wbsSendingTime;

    @Column(name = "MES_ORDER_SEQ")
    private Long mesOrderSeq;

    @Column(name = "ROUTE_MAP_METHOD")
    private Short routeMapMethod;

    @Column(name = "ON_PRE_SETOUT")
    private Short onPreSetout;

    @Column(name = "IS_TESTED")
    private Short isTested;

    @Column(name = "SVO_TYPE")
    private String svoType;

    @Column(name = "SVO_NO")
    private String svoNo;

    @Column(name = "SVO_VENDOR")
    private String svoVendor;

    @Column(name = "TESTED_REMARK")
    private String testedRemark;

    @Column(name = "VIN_CREATE")
    private String vinCreate;


}